{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Assignment (V2)","Prod not = demand (2)","muffins","Financial Information - data ","5.ID","Sheet9"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Assignment (V2)","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[" Demand not equal supply and Simulation",null,"Name ______________________________"]
[]
["1.       Randbetween Function? What does it do and what are the variables it uses? Enter response in A4"]
[]
[]
["     Start with the template of Prod not = demand.  "]
["    Assume Demand is Randomly distributed between 1000 and 6000. "]
["   Now assume Production doesn’t equal Demand.  Set production to 3500 units (coffee and Donuts) each month."]
[]
["2.       Which line now must change to be based off the production number? Enter response in A11"]
["Line 4"]
[]
["3.        What function can you use in Excel to calculate satisfied demand? ? Enter  just function name in cell A14"]
["MIN function "]
["4.       Which line must be changed to be based off the Satisfied demand number? Enter the Heading for the row in below yellow box"]
["Line 6"]
["5.       What formula will you use to calculate Unsatisfied customers/Lost sales expense? Enter  in below yellow box"]
["ABS(IF(B3-B4>0,B3-B4,0))"]
["6.        What formula will you use to calculate Revenue from Leftover donuts? Enter in below yellow box"]
["ABS(IF(B3-B4>0,0,B3-B4))"]
[" Unsatisfied customers/Lost sales(coffee and Donuts)  are set at $1.50.  Leftover donuts can be sold at a day old donut store for $1.00, the coffee is thrown out.  Add lines for both of these on your spread sheet. "]
["   7.  What sections will you add Left Overs to?  Enter in below yellow box."]
["Revenue "]
["   8.  What section will you add unhappy customer to?  Enter in below yellow box  "]
["Variable expense "]
[]
["9.   Using the Financial Information sheet for Muffin, create a copy of donut sheet (production not = Demand) fill in  the Spread sheet  for muffin (Using a Production level of 4000 )"]
["see in muffins tab"]
[]
["10.   What is the average yearly average profit for Donuts to Go and Mufffins to go?  Enter amount in line C31, round to 2 decimal points"]
[1496.36]
["LOAD YOUR completed excel files to  icollege folder,  (to get to: Assessment,  Assignments).  Name your file as:  Your last name crossover and Your last name "]

{"sheet":"Prod not = demand (2)","index":1,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["DTG","lines added or changed ",null,"Demand greater than","Demand less than ",null,"Production","Left over revenue","unhappy customers"]
[null,null,null,1000,6000,null,3500,1,1.5]
["Demand",4297,1151,2300,3450,5600,4356,2390,5300,2300,1860,2590,4890]
["Production",3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500]
["Month ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Quantity Sold/Satisfied Demand",{"$f":"MIN(B3,B4)","v":3500},{"$f":"MIN(C3,C4)","v":1151},2300,3450,3500,3500,2390,3500,2300,1860,2590,3500]
["Left Over Sales",{"$f":"ABS(IF(B3-B4>0,0,B3-B4))","v":0},{"$f":"ABS(IF(C3-C4>0,0,C3-C4))","v":2349},1200,50,0,0,1110,0,1200,1640,910,0]
["Lost Sales/Shortage",{"$f":"ABS(IF(B3-B4>0,B3-B4,0))","v":797},{"$f":"ABS(IF(C3-C4>0,C3-C4,0))","v":0},0,0,2100,{"$f":"ABS(IF(G3-G4>0,G3-G4,0))","v":856},0,1800,0,0,0,1390]
["Revenue"]
["coffee ",{"$f":"4*B6","v":14000},{"$f":"4*C6","v":4604},{"$f":"4*D6","v":9200},13800,14000,14000,9560,14000,9200,7440,10360,{"$f":"4*M6","v":14000}]
["donut",{"$f":"3.5*B6","v":12250},{"$f":"3.5*C6","v":4028.5},8050,12075,12250,12250,8365,12250,8050,6510,9065,12250]
["left over rev",{"$f":"B7*1","v":0},{"$f":"C7*1","v":2349},{"$f":"D7*1","v":1200},50,0,0,1110,0,1200,1640,910,0]
["Total Revenue",{"$f":"SUM(B10:B12)","v":26250},{"$f":"SUM(C10:C12)","v":10981.5},18450,25925,26250,26250,19035,26250,18450,15590,20335,26250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Fixed Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total Fixed Expense",{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550},{"$f":"5550","v":5550}]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"0.35*B4","v":1225},{"$f":"0.35*C4","v":1225},1225,1225,1225,1225,1225,1225,1225,1225,1225,1225]
["Donut Variable expense",{"$f":"0.6*B4","v":2100},{"$f":"0.6*C4","v":2100},{"$f":"0.6*D4","v":2100},2100,2100,2100,2100,2100,2100,2100,2100,2100]
["Unhappy Cust Exp",{"$f":"1.5*B8","v":1195.5},{"$f":"1.5*C8","v":0},0,0,3150,1284,0,2700,0,0,0,2085]
["Total Variable Expenses",{"$f":"SUM(B19:B21)","v":4520.5},{"$f":"SUM(C19:C21)","v":3325},3325,3325,6475,4609,3325,6025,3325,3325,3325,5410]
["Total  Expenses",{"$f":"B22+B16","v":10070.5},{"$f":"C22+C16","v":8875},8875,8875,12025,10159,8875,11575,8875,8875,8875,10960]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":16179.5},{"$f":"C13-C23","v":2106.5},9575,17050,14225,16091,10160,14675,9575,6715,11460,15290]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"muffins","index":2,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["MTG","lines added or changed ",null,"Demand greater than","Demand less than ",null,"Production","Left over revenue","unhappy customers"]
[null,null,null,1000,6000,null,4000,1,1.5]
["Demand",5848,5511,2300,3450,5600,4356,2390,5300,2300,1860,2590,4890]
["Production",4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000,4000]
["Month ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Quantity Sold/Satisfied Demand",{"$f":"MIN(B3,B4)","v":4000},{"$f":"MIN(C3,C4)","v":4000},2300,3450,4000,4000,2390,4000,2300,1860,2590,4000]
["Left Over Sales",{"$f":"ABS(IF(B3-B4>0,0,B3-B4))","v":0},{"$f":"ABS(IF(C3-C4>0,0,C3-C4))","v":0},1700,550,0,0,1610,0,1700,2140,1410,0]
["Lost Sales/Shortage",{"$f":"ABS(IF(B3-B4>0,B3-B4,0))","v":1848},{"$f":"ABS(IF(C3-C4>0,C3-C4,0))","v":1511},0,0,1600,{"$f":"ABS(IF(G3-G4>0,G3-G4,0))","v":356},0,1300,0,0,0,890]
["Revenue"]
["coffee ",{"$f":"4*B6","v":16000},{"$f":"4*C6","v":16000},{"$f":"4*D6","v":9200},13800,16000,16000,9560,16000,9200,7440,10360,{"$f":"4*M6","v":16000}]
["Muffins",{"$f":"5.5*B6","v":22000},{"$f":"5.5*C6","v":22000},12650,18975,22000,22000,13145,22000,12650,10230,14245,22000]
["left over rev",{"$f":"B7*1","v":0},{"$f":"C7*1","v":0},{"$f":"D7*1","v":1700},550,0,0,1610,0,1700,2140,1410,0]
["Total Revenue",{"$f":"SUM(B10:B12)","v":38000},{"$f":"SUM(C10:C12)","v":38000},23550,33325,38000,38000,24315,38000,23550,19810,26015,38000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Fixed Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Total Fixed Expense",9350,9350,9350,9350,9350,9350,9350,9350,9350,9350,9350,9350]
[]
["Variable Expenses"]
["Coffee Variable expense",{"$f":"0.35*B4","v":1400},{"$f":"0.35*C4","v":1400},1400,1400,1400,1400,1400,1400,1400,1400,1400,1400]
["Muffins Variable expense",{"$f":"1.2*B4","v":4800},{"$f":"1.2*C4","v":4800},4800,4800,4800,4800,4800,4800,4800,4800,4800,4800]
["Unhappy Cust Exp",{"$f":"1.5*B8","v":2772},{"$f":"1.5*C8","v":2266.5},0,0,2400,534,0,1950,0,0,0,1335]
["Total Variable Expenses",{"$f":"SUM(B19:B21)","v":8972},{"$f":"SUM(C19:C21)","v":8466.5},6200,6200,8600,6734,6200,8150,6200,6200,6200,7535]
["Total  Expenses",{"$f":"B22+B16","v":18322},{"$f":"C22+C16","v":17816.5},15550,15550,17950,16084,15550,17500,15550,15550,15550,16885]
["Profit Donuts and Coffee",{"$f":"B13-B23","v":19678},{"$f":"C13-C23","v":20183.5},8000,17775,20050,21916,8765,20500,8000,4260,10465,21115]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Financial Information - data ","index":3,"n_rows":56,"n_cols":26,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Donut Information ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andrice"]
["Based on the below data, create the profit model for Donuts to Go.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2020"]
["Assume that each customer will buy one donut and one cup of coffee"]
["Sales estimate range from 200-5000 per week "]
[]
[]
[null,"Time period"]
["Revenue: Cup of Coffee",null,4]
["Revenue: Donut"," ",3.5]
["Donut ingredients per donunt)","per donut",0.6,null,{"$f":"C12+C14+C15+C18+C19+C20+C21+C22+C23+C24+C26+C27","v":5550}]
["paper products: napkins, plates etc"]
["Insurance","month",200]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",50]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000]
["Donut and Coffee equipment rent ","month",500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",1000]
["Previous research expense for Donuts advancements",null,1500]
["Supplies: Office","month",25]
["Utilities","month",200]
[" ",null," "]
["Muffins to Go "]
["Assume that each customer will buy one muffin and one cup of coffee"]
["Sales estimate range from 200-5000 per week "]
[" "]
[]
["Muffin Financial Information "]
[null,"Time period"]
["Revenue: Cup of Coffee",null,4]
["Revenue: Muffin"," ",5.5]
["Muffin ingredients (per muffin)","per donut",1.2]
["paper products: napkins, plates etc"]
["Insurance","month",500]
[" "]
["Maintenance & Repairs to equipment","month",0]
["Marketing & Promotion: Advertising","month",250]
["Coffee ","per cup",0.25]
["Coffee cups ","per cup",0.1]
["Payroll:  Wages (Owner/ Manager)","month",2500]
["Payroll:  Wages (per Employees)","month",1000]
["Muffin and Coffee equipment rent ","month",2500]
["Professional Fees: Accounting","month",50]
["Professional Fees: Legal","month",25]
["Powdered and Liquid Beverages",null,0]
["Rent","month",2000]
["Previous research expense for Muffin advancements",null,2000]
["Supplies: Office","month",25]
["Utilities","month",500]
[" ",null," "]

{"sheet":"5.ID","index":4,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Do Not Alter or Delete this Worksheet or you submission cannot be graded!",null,null,null,"DirVer"]
["Action","Name","Panther ID","Date/Time","S01"]
["Start S01","Andrice",9999999,"2020-08-29T13:18:26.310","Microsoft Office User"]
["Starter Sheet","None",0,"2020-01-01"]
[null,null,null,null,"Welcome to Microsoft Excel version 16.16 build 810 running on Macintosh (Intel) Version 10.13.6 (Build 17G14019)!"]

{"sheet":"Sheet9","index":5,"n_rows":2,"n_cols":26,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andrice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spring 2020"]